SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

HttpToAnchors

Convert http found inside text into anchers < a >, aka URLlinker, aka ...

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

Bootstrap Modal variables

Bootstrap link to pass variables to modal content Used to build list of links ...

SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

Sheets to PDF pages

Export multiple sheets as pages in 1 pdf, doc, still rough and not elegant as ...

RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

CustomExcelMenu - FaceIDs

How to create custom Excel menu, this one shows the IDs and icons of 20 icons, ...

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

WelcomeSheet.zip

XLThumbView

Showing thumbnails inside sheet and enlarging each when click

XLThumbview.zip

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...